/*
 Navicat MySQL Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : localhost:3306
 Source Schema         : super_mario

 Target Server Type    : MySQL
 Target Server Version : 50719
 File Encoding         : 65001

 Date: 19/09/2019 15:12:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `blob_data` blob,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `sched_name` varchar(120) NOT NULL,
  `calendar_name` varchar(200) NOT NULL,
  `calendar` blob NOT NULL,
  PRIMARY KEY (`sched_name`,`calendar_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `cron_expression` varchar(200) NOT NULL,
  `time_zone_id` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', '0/10 * * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', '0/15 * * * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', '0/20 * * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL,
  `entry_id` varchar(95) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `instance_name` varchar(200) NOT NULL,
  `fired_time` bigint(13) NOT NULL,
  `sched_time` bigint(13) NOT NULL,
  `priority` int(11) NOT NULL,
  `state` varchar(16) NOT NULL,
  `job_name` varchar(200) DEFAULT NULL,
  `job_group` varchar(200) DEFAULT NULL,
  `is_nonconcurrent` varchar(1) DEFAULT NULL,
  `requests_recovery` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `sched_name` varchar(120) NOT NULL,
  `job_name` varchar(200) NOT NULL,
  `job_group` varchar(200) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `job_class_name` varchar(250) NOT NULL,
  `is_durable` varchar(1) NOT NULL,
  `is_nonconcurrent` varchar(1) NOT NULL,
  `is_update_data` varchar(1) NOT NULL,
  `requests_recovery` varchar(1) NOT NULL,
  `job_data` blob,
  PRIMARY KEY (`sched_name`,`job_name`,`job_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', NULL, 'com.wangjiang.mario.admin.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002E636F6D2E77616E676A69616E672E6D6172696F2E61646D696E2E71756172747A2E646F6D61696E2E5379734A6F62000000000000000102000F4C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C00116D697366697265506F6C6963794465736371007E00094C000672656D61726B71007E00094C000673746174757371007E00094C000A7374617475734465736371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000978707400013174000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001622CDE29E07874000E302F3130202A202A202A202A203F74001172795461736B2E72794E6F506172616D7374000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000001740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E697A0E58F82EFBC897400013370740000740001317070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', NULL, 'com.wangjiang.mario.admin.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002E636F6D2E77616E676A69616E672E6D6172696F2E61646D696E2E71756172747A2E646F6D61696E2E5379734A6F62000000000000000102000F4C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C00116D697366697265506F6C6963794465736371007E00094C000672656D61726B71007E00094C000673746174757371007E00094C000A7374617475734465736371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000978707400013174000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001622CDE29E07874000E302F3135202A202A202A202A203F74001572795461736B2E7279506172616D7328277279272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000002740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E69C89E58F82EFBC897400013370740000740001317070707800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', NULL, 'com.wangjiang.mario.admin.quartz.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372002E636F6D2E77616E676A69616E672E6D6172696F2E61646D696E2E71756172747A2E646F6D61696E2E5379734A6F62000000000000000102000F4C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C00116D697366697265506F6C6963794465736371007E00094C000672656D61726B71007E00094C000673746174757371007E00094C000A7374617475734465736371007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000978707400013174000561646D696E7372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001622CDE29E07874000E302F3230202A202A202A202A203F74003872795461736B2E72794D756C7469706C65506172616D7328277279272C20747275652C20323030304C2C203331362E3530442C203130302974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000003740018E7B3BBE7BB9FE9BB98E8AEA4EFBC88E5A49AE58F82EFBC897400013370740000740001317070707800);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `sched_name` varchar(120) NOT NULL,
  `lock_name` varchar(40) NOT NULL,
  PRIMARY KEY (`sched_name`,`lock_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` VALUES ('RuoyiScheduler', 'STATE_ACCESS');
INSERT INTO `QRTZ_LOCKS` VALUES ('RuoyiScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  PRIMARY KEY (`sched_name`,`trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `sched_name` varchar(120) NOT NULL,
  `instance_name` varchar(200) NOT NULL,
  `last_checkin_time` bigint(13) NOT NULL,
  `checkin_interval` bigint(13) NOT NULL,
  PRIMARY KEY (`sched_name`,`instance_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('RuoyiScheduler', 'chenqingdeMacBook-Pro.local1568876170666', 1568877148944, 15000);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `repeat_count` bigint(7) NOT NULL,
  `repeat_interval` bigint(12) NOT NULL,
  `times_triggered` bigint(10) NOT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `str_prop_1` varchar(512) DEFAULT NULL,
  `str_prop_2` varchar(512) DEFAULT NULL,
  `str_prop_3` varchar(512) DEFAULT NULL,
  `int_prop_1` int(11) DEFAULT NULL,
  `int_prop_2` int(11) DEFAULT NULL,
  `long_prop_1` bigint(20) DEFAULT NULL,
  `long_prop_2` bigint(20) DEFAULT NULL,
  `dec_prop_1` decimal(13,4) DEFAULT NULL,
  `dec_prop_2` decimal(13,4) DEFAULT NULL,
  `bool_prop_1` varchar(1) DEFAULT NULL,
  `bool_prop_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `QRTZ_TRIGGERS` (`sched_name`, `trigger_name`, `trigger_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `sched_name` varchar(120) NOT NULL,
  `trigger_name` varchar(200) NOT NULL,
  `trigger_group` varchar(200) NOT NULL,
  `job_name` varchar(200) NOT NULL,
  `job_group` varchar(200) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `next_fire_time` bigint(13) DEFAULT NULL,
  `prev_fire_time` bigint(13) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `trigger_state` varchar(16) NOT NULL,
  `trigger_type` varchar(8) NOT NULL,
  `start_time` bigint(13) NOT NULL,
  `end_time` bigint(13) DEFAULT NULL,
  `calendar_name` varchar(200) DEFAULT NULL,
  `misfire_instr` smallint(2) DEFAULT NULL,
  `job_data` blob,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
  KEY `sched_name` (`sched_name`,`job_name`,`job_group`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `QRTZ_JOB_DETAILS` (`sched_name`, `job_name`, `job_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME1', 'DEFAULT', 'TASK_CLASS_NAME1', 'DEFAULT', NULL, 1568876170000, -1, 5, 'PAUSED', 'CRON', 1568876170000, 0, NULL, 2, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME2', 'DEFAULT', 'TASK_CLASS_NAME2', 'DEFAULT', NULL, 1568876175000, -1, 5, 'PAUSED', 'CRON', 1568876170000, 0, NULL, 2, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('RuoyiScheduler', 'TASK_CLASS_NAME3', 'DEFAULT', 'TASK_CLASS_NAME3', 'DEFAULT', NULL, 1568876180000, -1, 5, 'PAUSED', 'CRON', 1568876170000, 0, NULL, 2, '');
COMMIT;

-- ----------------------------
-- Table structure for mario_job
-- ----------------------------
DROP TABLE IF EXISTS `mario_job`;
CREATE TABLE `mario_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
  `job_name` varchar(64) NOT NULL DEFAULT '' COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `cron_expression` varchar(255) DEFAULT '' COMMENT 'cron执行表达式',
  `misfire_policy` varchar(20) DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）',
  `concurrent` char(1) DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1暂停）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`,`job_name`,`job_group`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度表';

-- ----------------------------
-- Records of mario_job
-- ----------------------------
BEGIN;
INSERT INTO `mario_job` VALUES (1, '系统默认（无参）', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '');
INSERT INTO `mario_job` VALUES (2, '系统默认（有参）', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '');
INSERT INTO `mario_job` VALUES (3, '系统默认（多参）', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2018-03-16 11:33:00', 'ry', '2018-03-16 11:33:00', '');
COMMIT;

-- ----------------------------
-- Table structure for mario_job_log
-- ----------------------------
DROP TABLE IF EXISTS `mario_job_log`;
CREATE TABLE `mario_job_log` (
  `job_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID',
  `job_name` varchar(64) NOT NULL COMMENT '任务名称',
  `job_group` varchar(64) NOT NULL COMMENT '任务组名',
  `invoke_target` varchar(500) NOT NULL COMMENT '调用目标字符串',
  `job_message` varchar(500) DEFAULT NULL COMMENT '日志信息',
  `status` char(1) DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
  `exception_info` varchar(2000) DEFAULT '' COMMENT '异常信息',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务调度日志表';

-- ----------------------------
-- Table structure for mario_role
-- ----------------------------
DROP TABLE IF EXISTS `mario_role`;
CREATE TABLE `mario_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '角色编码',
  `role_name` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '角色名称',
  `role_type` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '角色分类（高管、中层、基层、其它）',
  `user_type` varchar(16) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户类型（employee员工 member会员）',
  `data_scope` char(1) CHARACTER SET utf8 DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `biz_scope` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '适应业务范围（不同的功能，不同的数据权限支持）',
  `tree_sort` decimal(10,0) DEFAULT NULL COMMENT '角色排序（升序）',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uuid_role` (`uuid`),
  UNIQUE KEY `role_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';

-- ----------------------------
-- Records of mario_role
-- ----------------------------
BEGIN;
INSERT INTO `mario_role` VALUES (1, 'admin', '管理员', '', '', '1', NULL, NULL, '5e59b265a74881ae4dbbf4f81542350b', '2019-08-29 17:39:42', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 10:59:17', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', 0, 1, 0, '', NULL);
INSERT INTO `mario_role` VALUES (2, 'testAdmin', '测试管理员', '', '', '2', NULL, NULL, '8276beca36c4452f999978d081aa4f8c', '2019-09-01 20:41:59', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 10:54:13', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `mario_role_dept`;
CREATE TABLE `mario_role_dept` (
  `role_code` varchar(100) NOT NULL COMMENT '角色uuid',
  `dept_code` varchar(100) NOT NULL COMMENT '部门code',
  PRIMARY KEY (`dept_code`,`role_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门与角色关联表';

-- ----------------------------
-- Records of mario_role_dept
-- ----------------------------
BEGIN;
INSERT INTO `mario_role_dept` VALUES ('admin', 'mario:chief');
INSERT INTO `mario_role_dept` VALUES ('admin', 'mario:product');
INSERT INTO `mario_role_dept` VALUES ('testAdmin', 'mario:product');
INSERT INTO `mario_role_dept` VALUES ('admin', 'mario:tech');
COMMIT;

-- ----------------------------
-- Table structure for mario_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `mario_role_menu`;
CREATE TABLE `mario_role_menu` (
  `role_code` varchar(64) NOT NULL COMMENT '角色编码',
  `menu_code` varchar(64) NOT NULL COMMENT '菜单编码',
  PRIMARY KEY (`role_code`,`menu_code`) USING BTREE,
  UNIQUE KEY `role_menu_unique` (`role_code`,`menu_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色与菜单关联表';

-- ----------------------------
-- Records of mario_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `mario_role_menu` VALUES ('admin', 'monitor');
INSERT INTO `mario_role_menu` VALUES ('admin', 'monitor:api');
INSERT INTO `mario_role_menu` VALUES ('admin', 'monitor:data');
INSERT INTO `mario_role_menu` VALUES ('admin', 'monitor:task');
INSERT INTO `mario_role_menu` VALUES ('admin', 'sys');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:dept');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:dict');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:menu');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:param');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:position');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:role');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:user');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:user:create');
INSERT INTO `mario_role_menu` VALUES ('admin', 'system:user:list');
INSERT INTO `mario_role_menu` VALUES ('testAdmin', 'monitor');
INSERT INTO `mario_role_menu` VALUES ('testAdmin', 'monitor:task');
INSERT INTO `mario_role_menu` VALUES ('testAdmin', 'sys');
INSERT INTO `mario_role_menu` VALUES ('testAdmin', 'system');
INSERT INTO `mario_role_menu` VALUES ('testAdmin', 'system:dept');
INSERT INTO `mario_role_menu` VALUES ('testAdmin', 'system:user');
INSERT INTO `mario_role_menu` VALUES ('testAdmin', 'system:user:create');
INSERT INTO `mario_role_menu` VALUES ('testAdmin', 'system:user:list');
COMMIT;

-- ----------------------------
-- Table structure for mario_system_config
-- ----------------------------
DROP TABLE IF EXISTS `mario_system_config`;
CREATE TABLE `mario_system_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `config_name` varchar(256) DEFAULT '' COMMENT '名称',
  `config_key` varchar(256) DEFAULT '' COMMENT '参数键',
  `config_value` varchar(256) DEFAULT '' COMMENT '参数值',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid_system_config` (`uuid`),
  UNIQUE KEY `uniq_key` (`config_key`,`del_flag`,`created_time`) USING BTREE COMMENT 'key 唯一键'
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='系统参数表';

-- ----------------------------
-- Records of mario_system_config
-- ----------------------------
BEGIN;
INSERT INTO `mario_system_config` VALUES (1, '站点名称', 'site.name', '后台基础开发平台', '828b16264391d14c521a71dac8a81327', '2019-08-19 13:48:17', '-1', 'nobody', '2019-08-19 13:48:17', '-1', 'nobody', 0, 1, 1, '', NULL);
INSERT INTO `mario_system_config` VALUES (4, '测试', 'test', '测试test字符', 'a162d05af7f368920bfd57d8afc8216b', '2019-08-19 14:02:43', '-1', 'nobody', '2019-08-19 14:02:43', '-1', 'nobody', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_config` VALUES (5, '测试2', 'test.name', '测试test字符.2', '6a2c7ffcdd9b0a8a93e1eee7e232d40a', '2019-08-19 14:15:08', '-1', 'nobody', '2019-08-19 14:15:08', '-1', 'nobody', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_config` VALUES (7, '开发者', 'site.author', '王将', 'b317ad93b7416bc19b585fe7ee214890', '2019-08-19 14:23:32', '-1', 'nobody', '2019-08-19 14:23:32', '-1', 'nobody', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_config` VALUES (8, '网址', 'site.url', '127.0.0.1', '873d693e93e64da76dc15ac2d6599cfb', '2019-08-19 14:25:57', '-1', 'nobody', '2019-08-19 15:18:13', '-1', 'nobody', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_config` VALUES (9, '初始账户密码', 'site.initPassword', '123456', 'f1218f464c9ff79ef78cf751dfaf9aff', '2019-08-28 09:47:42', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 09:47:42', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_config` VALUES (10, '上传路径', 'site.uploadPath', '/Users/chenqing/codeCache/mario-file/upload/', '1sd111', '2019-08-28 09:47:42', '-1', 'admin', NULL, '-1', 'admin', 0, 1, 1, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_system_dept
-- ----------------------------
DROP TABLE IF EXISTS `mario_system_dept`;
CREATE TABLE `mario_system_dept` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `dept_name` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '菜单名称',
  `code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '菜单编码',
  `tree_sort` decimal(10,0) NOT NULL COMMENT '本级排序号（升序）',
  `tree_sorts` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '所有级别排序号',
  `parent_code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '父级编号',
  `parent_codes` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '所有父级编号',
  `tree_leaf` char(1) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT '是否最末级',
  `tree_level` decimal(4,0) NOT NULL COMMENT '层次级别',
  `tree_names` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '全节点名',
  `sys_code` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT 'default' COMMENT '归属系统（default:主导航菜单、mobileApp:APP菜单）',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid_system_dict_type` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='系统菜单表';

-- ----------------------------
-- Records of mario_system_dept
-- ----------------------------
BEGIN;
INSERT INTO `mario_system_dept` VALUES (7, '任天堂公司', 'mario:chief', 10, '', '', '', '0', 0, '', 'default', 'b188877bb0eb9d6f8c96e5545fb81628', '2019-08-28 15:53:28', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 15:53:28', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dept` VALUES (8, '技术部', 'mario:tech', 10, '', 'mario:chief', '', '0', 1, '', 'default', '89aee3d43785c125b03e8b575ec4d012', '2019-08-28 15:55:10', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 15:55:10', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dept` VALUES (9, '产品部门', 'mario:product', 20, '', 'mario:chief', '', '0', 1, '', 'default', '3ad778e1a45f0335706fa8d2a6732c5c', '2019-09-09 09:30:56', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-09 09:30:56', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_system_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `mario_system_dict_data`;
CREATE TABLE `mario_system_dict_data` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `dict_label` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '字典标签',
  `dict_value` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '字典键值',
  `dict_type` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '字典类型',
  `tree_sort` decimal(10,0) NOT NULL COMMENT '本级排序号（升序）',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid_system_dict_type` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='数据字典数据表';

-- ----------------------------
-- Records of mario_system_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `mario_system_dict_data` VALUES (1, '启用', '1', 'default_status', 10, '344f6c3341c79d49be6146b526f39de3', '2019-08-27 17:04:20', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-27 17:56:45', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (2, '禁用', '0', 'default_status', 20, '93e36eb9ede671269e77c39ef25658d8', '2019-08-27 17:09:53', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-27 17:12:01', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (3, '菜单', 'menu', 'default_menu_type', 1, 'eb19694cf7b5faf6ce6f440efb8136bd', '2019-08-28 14:53:33', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 14:53:33', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (4, '权限', 'perm', 'default_menu_type', 1, '3066f80550088056759580b63e93f984', '2019-08-28 14:54:05', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 14:54:05', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (5, '其他', 'other', 'default_menu_type', 1, '11fe0d81cd93022f241dd611d33a80d7', '2019-08-28 14:54:37', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 14:54:37', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (6, '还有个其他', 'other1', 'default_menu_type', 1, '031691f24d87d9c22ed64596819e31a7', '2019-08-28 14:59:49', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 15:00:08', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (7, '还有其他', 'test', 'default_menu_type', 1, 'b019f27b27cfa84460756a482fed702d', '2019-08-28 15:01:53', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 15:01:58', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (8, '全部数据权限', '1', 'data_scope', 1, 'f3966d91dd5fe02d20da473ea252863e', '2019-08-29 17:23:46', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-29 17:23:46', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (9, '自定义数据权限', '2', 'data_scope', 2, '547969d5cf40a9d1d237a33de00e1a16', '2019-08-29 17:25:44', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-29 17:26:27', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (10, '本部门数据权限', '3', 'data_scope', 3, '933baf304b01d79bfc849d1fa7618588', '2019-08-29 17:26:34', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-29 17:26:34', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_data` VALUES (11, '本部门及以下数据权限', '4', 'data_scope', 4, 'a98fd9447e629d3e7fb8ba34627819d7', '2019-08-29 17:26:52', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-29 17:26:52', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_system_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `mario_system_dict_type`;
CREATE TABLE `mario_system_dict_type` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `dict_name` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '字典名称',
  `dict_type` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '字典类型',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid_system_dict_type` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='数据字典类型表';

-- ----------------------------
-- Records of mario_system_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `mario_system_dict_type` VALUES (1, '通用数据状态类型', 'default_status', '442c52bbb5b58e519865db651e56e846', '2019-08-27 13:38:03', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-27 17:58:56', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_type` VALUES (2, '通用删除状态类型', 'default_deleted_status', '5c6616326ed43b2ad4d9ebf607a07d68', '2019-08-27 13:53:09', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-27 13:53:09', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_type` VALUES (3, '测试状态', 'test_status', '07cff50c54f84910f4206497bd8215c7', '2019-08-27 14:33:44', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-27 14:33:44', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_type` VALUES (8, 'test2', 'test2', '3feb931a493755d4efddae8f2aac0aa7', '2019-08-27 14:40:09', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-27 15:36:56', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_type` VALUES (9, '默认菜单类型', 'default_menu_type', 'f301b98a9fd9b6eb9d0947bc5cc7291f', '2019-08-28 14:53:09', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 16:28:57', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_dict_type` VALUES (10, '数据权限范围', 'dataScope', 'f75fb7ccc8045fc89c5bc458756831b4', '2019-08-29 17:23:34', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-30 13:28:12', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_system_menu
-- ----------------------------
DROP TABLE IF EXISTS `mario_system_menu`;
CREATE TABLE `mario_system_menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `menu_name` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '菜单名称',
  `code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '菜单编码',
  `menu_type` varchar(4) CHARACTER SET utf8 NOT NULL DEFAULT 'menu' COMMENT '菜单类型（1菜单 2权限 3开发）',
  `menu_href` varchar(1000) CHARACTER SET utf8 DEFAULT NULL COMMENT '链接',
  `menu_target` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '目标',
  `menu_icon` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '图标',
  `menu_color` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '颜色',
  `menu_title` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单标题',
  `permission` varchar(1000) CHARACTER SET utf8 DEFAULT NULL COMMENT '权限标识',
  `is_show` char(1) CHARACTER SET utf8 NOT NULL COMMENT '是否显示（1显示 0隐藏）',
  `tree_sort` decimal(10,0) NOT NULL COMMENT '本级排序号（升序）',
  `tree_sorts` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '所有级别排序号',
  `parent_code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '父级编号',
  `parent_codes` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '所有父级编号',
  `tree_leaf` char(1) CHARACTER SET utf8 NOT NULL DEFAULT '0' COMMENT '是否最末级',
  `tree_level` decimal(4,0) NOT NULL COMMENT '层次级别',
  `tree_names` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '全节点名',
  `sys_code` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT 'default' COMMENT '归属系统（default:主导航菜单、mobileApp:APP菜单）',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uuid_system_dict_type` (`uuid`),
  UNIQUE KEY `menu_code_unique` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='系统菜单表';

-- ----------------------------
-- Records of mario_system_menu
-- ----------------------------
BEGIN;
INSERT INTO `mario_system_menu` VALUES (1, '系统设置', 'system', 'menu', 'string', 'string', 'string', 'string', 'menuTitle', 'sys', '1', 10, '', 'sys', '', '', 1, '', 'default', 'e19dbd43b01c51128d95553f567ac65b', '2019-08-23 16:50:47', '-1', 'nobody', '2019-09-11 15:07:27', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', 0, 1, 1, '', NULL);
INSERT INTO `mario_system_menu` VALUES (2, '用户管理', 'system:user', 'menu', 'string', 'string', 'string', 'string', 'menuTitle', 'sys:user', '1', 10, '', 'system', '', '', 2, '', 'default', 'e19dbd43b01c51128d95553f567ac65c', '2019-08-23 16:50:47', '-1', 'nobody', '2019-09-11 15:07:49', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', 0, 1, 1, '', NULL);
INSERT INTO `mario_system_menu` VALUES (3, '用户新增', 'system:user:create', 'perm', 'string', 'string', 'string', 'string', 'menuTitle', 'sys:user:create', '1', 10, '', 'system:user', '', '', 3, '', 'default', 'e19dbd43b01c51128d95553f567ac65d', '2019-08-23 16:50:47', '-1', 'nobody', '2019-09-11 15:09:07', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', 0, 1, 1, '', NULL);
INSERT INTO `mario_system_menu` VALUES (5, '角色管理', 'system:role', 'menu', NULL, NULL, NULL, NULL, '角色管理', 'system:role', '1', 20, '', 'system', '', '0', 2, '', 'default', '72fa481dcc0eab0ec731b11db35c16b0', '2019-08-28 14:04:00', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 15:09:40', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (6, '用户编辑', 'system:user:edit', 'perm', NULL, NULL, NULL, NULL, '用户编辑', 'system:user:edit', '0', 20, '', 'system:user', '', '0', 2, '', 'default', 'f91847aa07e706ef3e5f6b8eefbc85f4', '2019-08-28 14:43:10', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-28 14:44:37', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (7, '用户列表', 'system:user:list', 'perm', NULL, NULL, NULL, NULL, '用户列表', 'system:user:list', '0', 0, '', 'system:user', '', '0', 3, '', 'default', '3ca1e94ee93dba7a3b45466b70f88a4e', '2019-09-10 18:08:20', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', '2019-09-11 15:09:22', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (8, '系统管理', 'sys', 'menu', NULL, NULL, NULL, NULL, '系统管理', 'system', '1', 0, '', '', '', '0', 0, '', 'default', '1a5621723aa0b12a8e4def61c3aa2884', '2019-09-11 11:03:54', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 15:19:12', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (9, '部门管理', 'system:dept', 'menu', NULL, NULL, NULL, NULL, '部门管理', 'system:dept', '1', 15, '', 'system', '', '0', 2, '', 'default', 'c95fe0be5e7f097125c856b8e2c292a9', '2019-09-11 15:12:28', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', '2019-09-11 16:22:36', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (10, '字典管理', 'system:dict', 'menu', NULL, NULL, NULL, NULL, '字典管理', 'system:dict', '1', 30, '', 'system', '', '0', 2, '', 'default', 'fb0333b2bfacfc6156e0b28bdfd802a5', '2019-09-11 16:23:45', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 16:23:45', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (11, '参数管理', 'system:param', 'menu', NULL, NULL, NULL, NULL, '参数管理', 'system:param', '1', 40, '', 'system', '', '0', 2, '', 'default', '370f2a695107d33c5ad0f929b3d94dbd', '2019-09-11 16:37:36', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 16:37:36', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (12, '菜单管理', 'system:menu', 'menu', NULL, NULL, NULL, NULL, '菜单管理', 'system:menu', '1', 50, '', 'system', '', '0', 2, '', 'default', '64ee4e31d4bea22e8aba2d23c748feb9', '2019-09-19 14:23:23', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-19 14:23:23', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (13, '岗位管理', 'system:position', 'menu', NULL, NULL, NULL, NULL, '岗位管理', 'system:position', '1', 60, '', 'system', '', '0', 2, '', 'default', 'b14965d0464cfaf0bde4d5bf3c232845', '2019-09-19 14:24:12', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-19 14:24:12', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (14, '系统监控', 'monitor', 'menu', NULL, NULL, NULL, NULL, '系统监控', 'monitor', '1', 20, '', 'sys', '', '0', 1, '', 'default', '49e2957dcaa77dcdffce05d5bdf001fa', '2019-09-19 14:24:47', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-19 14:24:47', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (15, '定时任务', 'monitor:task', 'menu', NULL, NULL, NULL, NULL, '定时任务', 'monitor:task', '1', 10, '', 'monitor', '', '0', 2, '', 'default', '4868a4df5fae900f2982c2169759415e', '2019-09-19 14:25:35', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-19 14:25:35', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (16, '数据监控', 'monitor:data', 'menu', NULL, NULL, NULL, NULL, '数据监控', 'monitor:data', '1', 20, '', 'monitor', '', '0', 2, '', 'default', '7931541c950bea8dda3917f2516747c7', '2019-09-19 14:26:16', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-19 14:26:16', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_menu` VALUES (17, '系统接口', 'monitor:api', 'menu', NULL, NULL, NULL, NULL, '系统接口', 'monitor:api', '1', 30, '', 'monitor', '', '0', 2, '', 'default', '8ae84238abaeac2f229577921f6bd7af', '2019-09-19 14:26:50', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-19 14:26:50', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_system_position
-- ----------------------------
DROP TABLE IF EXISTS `mario_system_position`;
CREATE TABLE `mario_system_position` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `position_name` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '岗位名称',
  `code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '岗位编码',
  `dept_code` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '岗位编码',
  `dept_name` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '岗位编码',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uuid_system_dept` (`uuid`),
  UNIQUE KEY `system_position_code` (`code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='系统部门表';

-- ----------------------------
-- Records of mario_system_position
-- ----------------------------
BEGIN;
INSERT INTO `mario_system_position` VALUES (3, '董事长', 'master', 'mario:chief', '任天堂公司', '0d618346efee17edc99dd1a9793fc144', '2019-08-29 15:22:12', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-29 15:22:12', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_position` VALUES (4, '技术经理', 'tech:manager', 'mario:tech', '技术部', 'c5b9515b4f1148368b477cfbd12477a3', '2019-08-29 15:24:10', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-29 15:24:10', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_position` VALUES (5, '产品经理', 'pro:manager', 'mario:product', '产品部门', 'd6d75233a86fc96e4c9ac73162fab62c', '2019-09-11 10:53:14', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 10:53:14', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_system_position` VALUES (6, '产品助理', 'pro:assist', 'mario:product', '产品部门', 'b534a24665be9ee6094bff47d60a4025', '2019-09-11 10:53:32', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 10:53:32', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_upload_log
-- ----------------------------
DROP TABLE IF EXISTS `mario_upload_log`;
CREATE TABLE `mario_upload_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `origin_filename` varchar(256) DEFAULT '' COMMENT '初始文件名称',
  `upload_filename` varchar(256) DEFAULT '' COMMENT '上传后的文件名称',
  `has_resource` varchar(256) DEFAULT '1' COMMENT '是否存在源文件',
  `extension` varchar(256) DEFAULT '' COMMENT '文件后缀名',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uuid_mario_upload_log` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='文件上传日志表';

-- ----------------------------
-- Records of mario_upload_log
-- ----------------------------
BEGIN;
INSERT INTO `mario_upload_log` VALUES (1, '纽扣画2.jpg', '9dfedce85fb588c2cf0fc68ce69adfec.jpg', '0', 'jpg', '3539ab318c02203e00525348e98d5e06', '2019-09-19 12:02:10', '-1', 'nobody', '2019-09-19 12:04:55', '-1', 'nobody', 0, 1, 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_user
-- ----------------------------
DROP TABLE IF EXISTS `mario_user`;
CREATE TABLE `mario_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `real_name` varchar(256) DEFAULT '' COMMENT '真实姓名',
  `nickname` varchar(256) DEFAULT '' COMMENT '昵称',
  `login_name` varchar(256) DEFAULT '' COMMENT '登录名',
  `dept_code` varchar(256) DEFAULT '' COMMENT '部门编码',
  `password` varchar(256) DEFAULT '' COMMENT '密码',
  `user_type` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT 'admin' COMMENT '用户类型',
  `phone` varchar(256) DEFAULT '' COMMENT '手机',
  `email` varchar(256) DEFAULT '' COMMENT '邮箱',
  `uuid` varchar(100) NOT NULL COMMENT 'UUID',
  `created_time` datetime DEFAULT NULL COMMENT '创建日期',
  `created_by_id` varchar(256) DEFAULT '-1' COMMENT '创建人id',
  `created_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '创建人登录名',
  `updated_time` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by_id` varchar(256) DEFAULT '-1' COMMENT '更新人id',
  `updated_by_name` varchar(256) DEFAULT 'cannot record' COMMENT '更新人登录名',
  `del_flag` tinyint(1) DEFAULT '0' COMMENT '是否删除 1 删除, 0 未删除',
  `status` tinyint(1) DEFAULT '1' COMMENT '是否启用 1 启用, 0 停用',
  `is_system_data` tinyint(1) DEFAULT '0' COMMENT '是否系统数据 1 是, 0 不是',
  `description` varchar(512) DEFAULT '' COMMENT '描述',
  `remark` text COMMENT '备注信息',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uuid_user` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of mario_user
-- ----------------------------
BEGIN;
INSERT INTO `mario_user` VALUES (1, 'admin', 'admin', 'admin', '', '$2a$10$LtKrWSczZmA/5WVSK6c0SeDzXXiRH1V8oow6tbvOelQyQ4Zp7uMZC', 'admin', '110', '2@1.com', 'a1460b06ad89c825d1fb7a981ac16b56', '2019-08-14 15:58:06', '-1', 'nobody', '2019-09-05 10:02:42', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_user` VALUES (2, 'admin', 'admin1', 'admin1', '', '$2a$10$T8gJrCyXttpbYvQjLFt/p.3uE5bnJ7aqUbNAzbmu7mtqR2mtkVM7m', 'admin', '111', '222', 'bfee9d3638ecd2297527b9eeec33b5b1', '2019-08-20 13:58:55', '-1', 'nobody', '2019-09-05 10:20:22', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '', NULL);
INSERT INTO `mario_user` VALUES (3, '山岭巨人', '小小', 'xiaoxiao', '', '$2a$10$9.qOhNYJG3QPwTAIiVDO7.llfyHOLn.catXNOP3hQwbIebCwI2UhO', 'admin', '666', '4444', '7062d513e5daf357bfa83102b4fd9d98', '2019-08-20 15:18:15', '-1', 'nobody', '2019-09-05 10:20:26', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '2222', NULL);
INSERT INTO `mario_user` VALUES (4, '死亡骑士', 'DK', 'dk', '', '$2a$10$WtDwQMPs1otL0PYX8NJaa.H5oRhDCsWUhpxJ0/pwdDwXg7tGamHKa', 'admin', '1110001', '11@111.com', '1b413253c73c06194aa7ea36007e13d6', '2019-08-20 15:25:51', '-1', 'nobody', '2019-08-23 11:07:16', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '', NULL);
INSERT INTO `mario_user` VALUES (5, 'admin', 'admin1', 'admin1', '', '$2a$10$7hxzZKxbS2psWsN023TrCuv9wKZkuHb3sfY7EUgFzuo0m4FtqZase', 'admin', '11000', '111111@1.com', 'ee31e84b3d022b9ae0a0a084cdabc87e', '2019-08-20 16:41:13', '-1', 'nobody', '2019-08-29 15:49:03', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 0, 0, '', NULL);
INSERT INTO `mario_user` VALUES (7, 'test', 'test', 'test', '', '$2a$10$.IrtjL4quy08gvefFzZrFuHnA.O3KkpgHJuYe1mOngihBal5v38He', 'admin', 'test', '111@11.com', '8177cb509266d7b6966d66ae87bf64d5', '2019-08-23 16:05:46', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-08-29 15:49:03', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '', NULL);
INSERT INTO `mario_user` VALUES (8, '剑圣', 'jugg', 'jiansheng', '', '$2a$10$xiuSR11u/feFDC1gPNOAN.5RDo8ahIxjHWx7MfnnQdemF1x6/Gmlm', 'admin', '10001', 'kk2kk2k@111.com', '9ddcfca7a344c2fc70504605ee845ead', '2019-09-04 09:42:01', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-04 10:03:15', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 1, 1, 0, '', NULL);
INSERT INTO `mario_user` VALUES (9, '剑圣', 'jugg', 'jiansheng', '', '$2a$10$o6SEOAa4T19m98J7k.dHLucuunwR.n4WpcW2KLfnhbd81huplm2ZK', 'admin', '10001', 'kk2kk2k@111.com', 'cef06c84a1aa5dae5ee97852502e28d8', '2019-09-04 10:02:57', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-04 10:02:57', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_user` VALUES (10, '幽鬼', 'ug', 'ug', 'mario:chief', '$2a$10$8qxoV5atp8CBKVRze6qsh.7GT9hRYncANZZqnSajzqPvGSebkgO4i', 'admin', '11111', '2@11.com', '4bb39a8a4027bf5a693156b84dcf2fde', '2019-09-05 09:17:47', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 10:50:33', '4bb39a8a4027bf5a693156b84dcf2fde', 'ug', 0, 1, 0, '', NULL);
INSERT INTO `mario_user` VALUES (11, '幻影刺客', 'pa', 'PA', 'mario:tech', '$2a$10$avhzCLh1ZdNLY6p/VL5qreHXBz2KnZAnZuJn3ztvD4Hmc0dcq5cDq', 'admin', '1111', '1jjj@1.com', '51f61b0230c5767ec37785cd5f618500', '2019-09-05 09:19:52', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-19 14:41:11', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
INSERT INTO `mario_user` VALUES (12, '暗影猎手', 'xiaoy', 'xiaoy', 'mario:product', '$2a$10$2M9Abvpw/jzfy0ONbTLuF.A/jVGmGTaN7aI9EHplcp8nqpvzMlI/2', 'admin', '111212', '1111@12.com', '3d3505f1851034c44f658500c140dc33', '2019-09-05 09:24:11', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', '2019-09-11 10:53:55', 'a1460b06ad89c825d1fb7a981ac16b56', 'admin', 0, 1, 0, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mario_user_dept
-- ----------------------------
DROP TABLE IF EXISTS `mario_user_dept`;
CREATE TABLE `mario_user_dept` (
  `user_id` varchar(100) NOT NULL COMMENT '用户ID',
  `dept_code` varchar(100) NOT NULL COMMENT '部门code',
  PRIMARY KEY (`user_id`,`dept_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户和部门关联表';

-- ----------------------------
-- Records of mario_user_dept
-- ----------------------------
BEGIN;
INSERT INTO `mario_user_dept` VALUES ('3d3505f1851034c44f658500c140dc33', 'mario:product');
INSERT INTO `mario_user_dept` VALUES ('499db9955f5c8c520ba896e775e16158', 'mario:chief');
INSERT INTO `mario_user_dept` VALUES ('4bb39a8a4027bf5a693156b84dcf2fde', 'mario:chief');
INSERT INTO `mario_user_dept` VALUES ('51f61b0230c5767ec37785cd5f618500', 'mario:tech');
INSERT INTO `mario_user_dept` VALUES ('835e952bb76677bc786c113e62076dda', 'mario:chief');
INSERT INTO `mario_user_dept` VALUES ('9d1255d49e8fb5d195ca2cb0e4de99e1', 'mario:chief');
INSERT INTO `mario_user_dept` VALUES ('9f7150e76f1bac6bd9704ca012aebef7', 'mario:tech');
INSERT INTO `mario_user_dept` VALUES ('a1460b06ad89c825d1fb7a981ac16b56', 'mario:tech');
INSERT INTO `mario_user_dept` VALUES ('a76af3b3e3a332b147968d4ada285229', 'mario:tech');
INSERT INTO `mario_user_dept` VALUES ('b444d7f3c220e4d7b2c420931842f0e3', 'mario:tech');
INSERT INTO `mario_user_dept` VALUES ('cef06c84a1aa5dae5ee97852502e28d8', 'mario:tech');
COMMIT;

-- ----------------------------
-- Table structure for mario_user_position
-- ----------------------------
DROP TABLE IF EXISTS `mario_user_position`;
CREATE TABLE `mario_user_position` (
  `user_id` varchar(100) NOT NULL COMMENT '用户ID',
  `position_code` varchar(100) NOT NULL COMMENT '岗位code',
  PRIMARY KEY (`user_id`,`position_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户和岗位关联表';

-- ----------------------------
-- Records of mario_user_position
-- ----------------------------
BEGIN;
INSERT INTO `mario_user_position` VALUES ('3d3505f1851034c44f658500c140dc33', 'pro:assist');
INSERT INTO `mario_user_position` VALUES ('499db9955f5c8c520ba896e775e16158', 'master');
INSERT INTO `mario_user_position` VALUES ('4bb39a8a4027bf5a693156b84dcf2fde', 'master');
INSERT INTO `mario_user_position` VALUES ('51f61b0230c5767ec37785cd5f618500', 'tech:manager');
INSERT INTO `mario_user_position` VALUES ('835e952bb76677bc786c113e62076dda', 'master');
INSERT INTO `mario_user_position` VALUES ('9d1255d49e8fb5d195ca2cb0e4de99e1', 'master');
INSERT INTO `mario_user_position` VALUES ('9f7150e76f1bac6bd9704ca012aebef7', 'tech:manager');
INSERT INTO `mario_user_position` VALUES ('a1460b06ad89c825d1fb7a981ac16b56', 'tech:manager');
INSERT INTO `mario_user_position` VALUES ('a76af3b3e3a332b147968d4ada285229', 'tech:manager');
INSERT INTO `mario_user_position` VALUES ('b444d7f3c220e4d7b2c420931842f0e3', 'tech:manager');
INSERT INTO `mario_user_position` VALUES ('cef06c84a1aa5dae5ee97852502e28d8', 'tech:manager');
COMMIT;

-- ----------------------------
-- Table structure for mario_user_role
-- ----------------------------
DROP TABLE IF EXISTS `mario_user_role`;
CREATE TABLE `mario_user_role` (
  `user_uuid` varchar(100) NOT NULL COMMENT '用户uuid',
  `role_code` varchar(100) NOT NULL COMMENT '角色uuid',
  PRIMARY KEY (`user_uuid`,`role_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户与角色关联表';

-- ----------------------------
-- Records of mario_user_role
-- ----------------------------
BEGIN;
INSERT INTO `mario_user_role` VALUES ('3d3505f1851034c44f658500c140dc33', 'admin');
INSERT INTO `mario_user_role` VALUES ('3d3505f1851034c44f658500c140dc33', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('499db9955f5c8c520ba896e775e16158', 'admin');
INSERT INTO `mario_user_role` VALUES ('499db9955f5c8c520ba896e775e16158', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('4bb39a8a4027bf5a693156b84dcf2fde', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('51f61b0230c5767ec37785cd5f618500', 'admin');
INSERT INTO `mario_user_role` VALUES ('51f61b0230c5767ec37785cd5f618500', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('835e952bb76677bc786c113e62076dda', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('9d1255d49e8fb5d195ca2cb0e4de99e1', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('9f7150e76f1bac6bd9704ca012aebef7', 'admin');
INSERT INTO `mario_user_role` VALUES ('9f7150e76f1bac6bd9704ca012aebef7', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('a1460b06ad89c825d1fb7a981ac16b56', 'admin');
INSERT INTO `mario_user_role` VALUES ('a1460b06ad89c825d1fb7a981ac16b56', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('a76af3b3e3a332b147968d4ada285229', 'admin');
INSERT INTO `mario_user_role` VALUES ('a76af3b3e3a332b147968d4ada285229', 'testAdmin');
INSERT INTO `mario_user_role` VALUES ('b444d7f3c220e4d7b2c420931842f0e3', 'admin');
INSERT INTO `mario_user_role` VALUES ('b444d7f3c220e4d7b2c420931842f0e3', 'testAdmin');
COMMIT;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `run_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;
